# !/bin/bash



 /opt/module/sqoop/bin/sqoop export \
--connect "jdbc:mysql://node101:3306/xm1_lx?useUnicode=true&characterEncoding=utf-8" \
--username root \
--password 123456 \
--table traffic_view_report \
--export-dir /user/spark/warehouse/zg6_xm1_lx/ads \
--input-fields-terminated-by "\001" \
--update-mode allowinsert \
 --update-key "dt,recent_days,province,city" \
       --num-mappers 1 \
       --input-null-string '\\N' \
       --input-null-non-string '\\N'